# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 localhost
# Database:             tyms
# Server version:       5.0.27-community
# Server OS:            Win32
# HeidiSQL version:     3.0 RC2 Revision: 55
# --------------------------------------------------------

#
# Dumping data for table 'bus_order'
#


#
# Dumping data for table 'customer'
#


#
# Dumping data for table 'customer_company'
#


#
# Dumping data for table 'dictionary_sub'
#

/*!40000 ALTER TABLE dictionary_sub DISABLE KEYS */;
LOCK TABLES dictionary_sub WRITE;
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('101','1','MALE','MALE');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('102','1','FEMALE','FEMALE');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('201','2','BRANCH_MANAGER','BRANCH_MANAGER');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('202','2','WITHOUT_TITLE','WITHOUT_TITLE');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('301','3','OTHER','OTHER');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('302','3','DOCTOR','DOCTOR');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('303','3','MASTER','MASTER');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('304','3','BACHELOR','BACHELOR');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('401','4','SALES_1','SALES_1');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('402','4','SALES_2','SALES_2');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('403','4','SALES_3','SALES_3');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('404','4','CLERK_OFFICE','CLERK_OFFICE');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('501','5','NONE','NONE');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('502','5','REGISTERING','REGISTERING');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('601','6','PRESIDENT','PRESIDENT');
INSERT INTO dictionary_sub (DICTIONARY_SUB_ID, Dictionary_ID, DICTIONARY_SUB_NAME, CODE) VALUES ('602','6','SUPERVISOR','SUPERVISOR');
UNLOCK TABLES;
/*!40000 ALTER TABLE dictionary_sub ENABLE KEYS */;

#
# Dumping data for table 'employee'
#


#
# Dumping data for table 'function'
#

/*!40000 ALTER TABLE function DISABLE KEYS */;
LOCK TABLES function WRITE;
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('1','基础数据维护',NULL,'','','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('102','员工信息','1','employee/employee.action','/employee','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('103','客户信息','1','customerCompany/customerCompany.action','/customerCompany','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('104','角色维护','1','role/role.action','/permission','');
UNLOCK TABLES;
/*!40000 ALTER TABLE function ENABLE KEYS */;

#
# Dumping data for table 'permission'
#

/*!40000 ALTER TABLE permission DISABLE KEYS */;
LOCK TABLES permission WRITE;
INSERT INTO permission (PERMISSION_ID, ROLE_ID, Function_ID, PERMISSION) VALUES ('1','2','102','1');
INSERT INTO permission (PERMISSION_ID, ROLE_ID, Function_ID, PERMISSION) VALUES ('2','2','103','1');
UNLOCK TABLES;
/*!40000 ALTER TABLE permission ENABLE KEYS */;

#
# Dumping data for table 'role'
#

/*!40000 ALTER TABLE role DISABLE KEYS */;
LOCK TABLES role WRITE;
INSERT INTO role (ROLE_ID, ROLE_NAME, IS_ADMIN) VALUES ('1','管理员',1);
INSERT INTO role (ROLE_ID, ROLE_NAME, IS_ADMIN) VALUES ('2','asdfa',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE role ENABLE KEYS */;

#
# Dumping data for table 'user'
#

/*!40000 ALTER TABLE user DISABLE KEYS */;
LOCK TABLES user WRITE;
INSERT INTO user (USER_ID, LOGIN_ID, LOGIN_PWD, CREATED_DATE, LAST_MODIFIED, ROLE_ID) VALUES ('1','admin',NULL,'1899-12-30 19:00:00','1899-12-30 19:00:00','1');
UNLOCK TABLES;
/*!40000 ALTER TABLE user ENABLE KEYS */;
